explain.depesz.com

PostgreSQL's explain analyze made readable

Result: wmKd

Settings
# exclusive inclusive rows x rows loops node
1. 66.801 1,311.218 ↑ 2,250.0 1 1

Planning Time: 1.407 msGather (cost=100,836.88..392,264.75 rows=2,250 width=179) (actual time=1,281.675..1,311.218 rows=1 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
2. 428.633 1,244.417 ↓ 0.0 0 3 / 3

Parallel Hash Join (cost=99,836.88..391,039.75 rows=938 width=179) (actual time=1,222.616..1,244.417 rows=0 loops=3)

  • Hash Cond: ((o.active_transaction_id = t_5.id) AND (o.ticket_id_ticket = t_5.ticket_id_ticket) AND (o.ticket_id_branch = t_5.ticket_id_branch))
3. 0.080 0.080 ↑ 3,101.9 18 3 / 3

Parallel Hash (cost=98,859.77..98,859.77 rows=55,835 width=77) (actual time=0.080..0.080 rows=18 loops=3)

4. 186.465 815.704 ↑ 1.2 3,333,333 3 / 3

Parallel Append (cost=0.00..244,323.99 rows=4,166,664 width=102) (actual time=0.079..815.704 rows=3,333,333 loops=3)

  • Buckets: 262,144 Batches: 1 Memory Usage: 2,080kB
5. 87.442 87.442 ↓ 2.4 1,250,000 1 / 3

Parallel Seq Scan on offer_p07 o_7 (cost=0.00..27,936.33 rows=520,833 width=102) (actual time=0.040..262.327 rows=1,250,000 loops=1)

6. 79.754 79.754 ↓ 2.4 1,250,000 1 / 3

Parallel Seq Scan on offer_p06 o_6 (cost=0.00..27,936.33 rows=520,833 width=102) (actual time=0.017..239.263 rows=1,250,000 loops=1)

7. 79.101 79.101 ↓ 1.2 625,000 2 / 3

Parallel Seq Scan on offer_p05 o_5 (cost=0.00..27,936.33 rows=520,833 width=102) (actual time=0.055..118.651 rows=625,000 loops=2)

8. 85.923 85.923 ↑ 1.2 416,667 3 / 3

Parallel Seq Scan on offer_p04 o_4 (cost=0.00..27,936.33 rows=520,833 width=102) (actual time=0.082..85.923 rows=416,667 loops=3)

9. 40.671 40.671 ↓ 2.4 1,250,000 1 / 3

Parallel Seq Scan on offer_p03 o_3 (cost=0.00..27,936.33 rows=520,833 width=102) (actual time=0.008..122.012 rows=1,250,000 loops=1)

10. 82.499 82.499 ↓ 2.4 1,250,000 1 / 3

Parallel Seq Scan on offer_p02 o_2 (cost=0.00..27,936.33 rows=520,833 width=102) (actual time=0.116..247.498 rows=1,250,000 loops=1)

11. 90.432 90.432 ↓ 2.4 1,250,000 1 / 3

Parallel Seq Scan on offer_p01 o_1 (cost=0.00..27,936.33 rows=520,833 width=102) (actual time=0.091..271.297 rows=1,250,000 loops=1)

12. 83.369 83.369 ↓ 2.4 1,250,000 1 / 3

Parallel Seq Scan on offer_p00 o (cost=0.00..27,936.33 rows=520,833 width=102) (actual time=0.105..250.107 rows=1,250,000 loops=1)

13. 0.002 0.047 ↑ 1,015.2 55 1 / 3

Parallel Append (cost=0.27..98,859.77 rows=55,835 width=77) (actual time=0.017..0.141 rows=55 loops=1)

14. 0.004 0.004 ↑ 1,233.5 8 1 / 3

Parallel Index Scan using transaction_p07_ticket_id_ticket_ticket_id_branch_id_partit_idx on transaction_p07 t_7 (cost=0.27..12,498.75 rows=9,868 width=77) (actual time=0.004..0.013 rows=8 loops=1)

15. 0.008 0.008 ↑ 2,271.8 4 1 / 3

Parallel Index Scan using transaction_p06_ticket_id_ticket_ticket_id_branch_id_partit_idx on transaction_p06 t_6 (cost=0.27..11,456.04 rows=9,087 width=77) (actual time=0.016..0.023 rows=4 loops=1)

16. 0.003 0.003 ↑ 2,681.0 4 1 / 3

Parallel Index Scan using transaction_p05_ticket_id_ticket_ticket_id_branch_id_partit_idx on transaction_p05 t_5 (cost=0.27..13,230.00 rows=10,724 width=77) (actual time=0.004..0.009 rows=4 loops=1)

17. 0.011 0.011 ↑ 1,096.2 9 1 / 3

Parallel Index Scan using transaction_p04_ticket_id_ticket_ticket_id_branch_id_partit_idx on transaction_p04 t_4 (cost=0.27..12,363.06 rows=9,866 width=77) (actual time=0.021..0.033 rows=9 loops=1)

18. 0.002 0.002 ↑ 3,432.7 3 1 / 3

Parallel Index Scan using transaction_p03_ticket_id_ticket_ticket_id_branch_id_partit_idx on transaction_p03 t_3 (cost=0.27..12,914.60 rows=10,298 width=77) (actual time=0.003..0.007 rows=3 loops=1)

19. 0.005 0.005 ↑ 1,221.9 8 1 / 3

Parallel Index Scan using transaction_p02_ticket_id_ticket_ticket_id_branch_id_partit_idx on transaction_p02 t_2 (cost=0.27..12,177.77 rows=9,775 width=77) (actual time=0.006..0.015 rows=8 loops=1)

20. 0.006 0.006 ↑ 926.4 10 1 / 3

Parallel Index Scan using transaction_p01_ticket_id_ticket_ticket_id_branch_id_partit_idx on transaction_p01 t_1 (cost=0.27..11,652.97 rows=9,264 width=77) (actual time=0.006..0.019 rows=10 loops=1)

21. 0.005 0.005 ↑ 1,104.9 9 1 / 3

Parallel Index Scan using transaction_p00_ticket_id_ticket_ticket_id_branch_id_partit_idx on transaction_p00 t (cost=0.27..12,287.41 rows=9,944 width=77) (actual time=0.005..0.015 rows=9 loops=1)

Execution time : 1,311.490 ms