explain.depesz.com

PostgreSQL's explain analyze made readable

Result: vjpK

Settings
# exclusive inclusive rows x rows loops node
1. 78.899 2,020.379 ↑ 2,250.0 1 1

Gather (cost=100,836.88..392,264.75 rows=2,250 width=55) (actual time=1,992.177..2,020.379 rows=1 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
2. 223.290 1,941.480 ↓ 0.0 0 3 / 3

Parallel Hash Join (cost=99,836.88..391,039.75 rows=938 width=55) (actual time=1,906.116..1,941.480 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. 181.183 1,718.095 ↑ 1.2 3,333,333 3 / 3

Parallel Append (cost=0.00..244,323.99 rows=4,166,664 width=42) (actual time=0.105..1,718.095 rows=3,333,333 loops=3)

4. 210.954 210.954 ↓ 2.4 1,250,000 1 / 3

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

5. 191.647 191.647 ↓ 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=42) (actual time=0.144..574.941 rows=1,250,000 loops=1)

6. 187.593 187.593 ↓ 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=42) (actual time=0.141..562.780 rows=1,250,000 loops=1)

7. 188.791 188.791 ↓ 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=42) (actual time=0.005..566.372 rows=1,250,000 loops=1)

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

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

9. 191.521 191.521 ↓ 1.2 625,000 2 / 3

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

10. 185.014 185.014 ↓ 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=42) (actual time=0.036..555.043 rows=1,250,000 loops=1)

11. 195.647 195.647 ↓ 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=42) (actual time=0.033..586.940 rows=1,250,000 loops=1)

12. 0.032 0.095 ↑ 3,101.9 18 3 / 3

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

  • Buckets: 262,144 Batches: 1 Memory Usage: 2,080kB
13. 0.005 0.063 ↑ 1,015.2 55 1 / 3

Parallel Append (cost=0.27..98,859.77 rows=55,835 width=29) (actual time=0.025..0.188 rows=55 loops=1)

14. 0.004 0.004 ↑ 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=29) (actual time=0.006..0.013 rows=4 loops=1)

15. 0.003 0.003 ↑ 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=29) (actual time=0.004..0.008 rows=3 loops=1)

16. 0.011 0.011 ↑ 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=29) (actual time=0.017..0.032 rows=8 loops=1)

17. 0.007 0.007 ↑ 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=29) (actual time=0.007..0.021 rows=9 loops=1)

18. 0.008 0.008 ↑ 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=29) (actual time=0.005..0.024 rows=9 loops=1)

19. 0.007 0.007 ↑ 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=29) (actual time=0.007..0.020 rows=8 loops=1)

20. 0.008 0.008 ↑ 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=29) (actual time=0.006..0.023 rows=10 loops=1)

21. 0.010 0.010 ↑ 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=29) (actual time=0.023..0.031 rows=4 loops=1)

Planning time : 1.606 ms
Execution time : 2,020.467 ms