explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ADPv

Settings
# exclusive inclusive rows x rows loops node
1. 5.328 272.234 ↑ 1.0 1 1

GroupAggregate (cost=20,000,017,289.37..480,000,037,974.60 rows=1 width=88) (actual time=272.113..272.234 rows=1 loops=1)

  • Group Key: NULL::integer
2. 6.032 266.906 ↓ 1.5 12,972 1

Hash Left Join (cost=20,000,017,289.37..480,000,037,866.17 rows=8,674 width=44) (actual time=68.332..266.906 rows=12,972 loops=1)

  • Hash Cond: ("*SELECT* 1".se_id = (jet.key)::integer)
3. 7.589 260.874 ↓ 1.5 12,972 1

Hash Join (cost=20,000,017,287.12..480,000,037,766.33 rows=8,674 width=12) (actual time=68.269..260.874 rows=12,972 loops=1)

  • Hash Cond: (c.br_id = b.id)
4. 30.083 253.285 ↓ 1.5 12,972 1

Hash Join (cost=20,000,017,285.74..480,000,037,736.51 rows=8,674 width=16) (actual time=68.220..253.285 rows=12,972 loops=1)

  • Hash Cond: ("*SELECT* 1".zo_id = z.id)
5. 23.369 223.202 ↓ 1.5 12,972 1

Hash Join (cost=20,000,016,656.96..480,000,037,084.96 rows=8,674 width=20) (actual time=46.157..223.202 rows=12,972 loops=1)

  • Hash Cond: ("*SELECT* 1".co_id = c.lo_id)
6. 113.356 199.833 ↓ 1.5 12,972 1

Append (cost=20,000,016,286.45..480,000,036,691.67 rows=8,674 width=20) (actual time=31.929..199.833 rows=12,972 loops=1)

7. 1.491 86.477 ↑ 1.8 4,703 1

Subquery Scan on *SELECT* 1 (cost=20,000,016,286.45..20,000,017,680.36 rows=8,652 width=20) (actual time=31.927..86.477 rows=4,703 loops=1)

8. 1.855 84.986 ↑ 1.8 4,703 1

Nested Loop (cost=20,000,016,286.45..20,000,017,593.84 rows=8,652 width=60) (actual time=31.925..84.986 rows=4,703 loops=1)

9. 0.021 0.021 ↑ 1.0 1 1

Seq Scan on rtbr_102095 b_1 (cost=0.00..1.21 rows=1 width=4) (actual time=0.019..0.021 rows=1 loops=1)

  • Filter: (id = 926)
  • Rows Removed by Filter: 16
10. 23.020 83.110 ↑ 1.8 4,703 1

Hash Join (cost=10,000,016,286.45..10,000,017,506.10 rows=8,652 width=24) (actual time=31.899..83.110 rows=4,703 loops=1)

  • Hash Cond: (av_.zo_id = z_1.id)
11. 1.761 60.090 ↑ 1.8 4,703 1

Nested Loop (cost=10,000,015,657.67..10,000,016,854.61 rows=8,652 width=24) (actual time=11.978..60.090 rows=4,703 loops=1)

12. 0.033 0.033 ↑ 1.0 1 1

Index Scan using idx_sepead_140422 on rt_sepeadsh_140422 av_1 (cost=0.28..8.30 rows=1 width=10) (actual time=0.029..0.033 rows=1 loops=1)

  • Index Cond: ((se_id = 12) AND (pe_id = 70) AND (ad_id = 335))
  • Filter: (id = 2,342)
13. 10.474 58.296 ↑ 1.8 4,703 1

Hash Join (cost=15,657.39..16,759.79 rows=8,652 width=30) (actual time=11.941..58.296 rows=4,703 loops=1)

  • Hash Cond: (av_.co_id = act.co_id)
14. 17.198 47.822 ↑ 3.0 4,775 1

Hash Join (cost=244.93..1,310.01 rows=14,207 width=26) (actual time=4.988..47.822 rows=4,775 loops=1)

  • Hash Cond: (av_.co_id = c_1.lo_id)
15. 25.788 25.788 ↑ 1.0 49,523 1

Seq Scan on rtsepezocoav_12_70_335_292247 av_ (cost=0.00..935.04 rows=49,523 width=18) (actual time=0.039..25.788 rows=49,523 loops=1)

  • Filter: (combi_id = 2,342)
16. 2.175 4.836 ↑ 1.0 3,806 1

Hash (cost=197.36..197.36 rows=3,806 width=8) (actual time=4.835..4.836 rows=3,806 loops=1)

  • Buckets: 4,096 Batches: 1 Memory Usage: 181kB
17. 2.661 2.661 ↑ 1.0 3,806 1

Bitmap Heap Scan on rtco_120185 c_1 (cost=77.78..197.36 rows=3,806 width=8) (actual time=0.545..2.661 rows=3,806 loops=1)

  • Recheck Cond: (br_id = 926)
  • Heap Blocks: exact=26