explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Pg0X

Settings
# exclusive inclusive rows x rows loops node
1. 0.010 277.881 ↑ 1.0 25 1

Limit (cost=24,898.42..25,220.52 rows=25 width=1,838) (actual time=275.361..277.881 rows=25 loops=1)

2. 0.145 277.871 ↑ 36,369.5 25 1

Nested Loop (cost=24,898.42..11,739,478.34 rows=909,238 width=1,838) (actual time=275.359..277.871 rows=25 loops=1)

3. 1.490 276.651 ↑ 36,369.5 25 1

Hash Left Join (cost=24,897.99..1,689,012.62 rows=909,238 width=1,709) (actual time=275.249..276.651 rows=25 loops=1)

  • Hash Cond: (reviews.review_id = review_responses.review_id)
4. 1.123 1.123 ↑ 13,988.3 65 1

Seq Scan on reviews (cost=0.00..1,328,818.04 rows=909,238 width=1,431) (actual time=0.027..1.123 rows=65 loops=1)

  • Filter: ((NOT is_done) AND (account_id = '9bccfdd7-67c7-45d3-8a37-14f5c8dd4de6'::uuid) AND (source_provider = ANY ('{11,16,2,3,6}'::integer[])))
  • Rows Removed by Filter: 163
5. 177.160 274.038 ↑ 1.0 216,470 1

Hash (cost=13,732.33..13,732.33 rows=216,533 width=294) (actual time=274.037..274.038 rows=216,470 loops=1)

  • Buckets: 131072 Batches: 4 Memory Usage: 18198kB
6. 96.878 96.878 ↑ 1.0 216,470 1

Seq Scan on review_responses (cost=0.00..13,732.33 rows=216,533 width=294) (actual time=0.022..96.878 rows=216,470 loops=1)

7. 0.225 0.225 ↑ 1.0 1 25

Index Scan using locations_pkey on locations (cost=0.42..1.99 rows=1 width=81) (actual time=0.009..0.009 rows=1 loops=25)

  • Index Cond: (location_id = reviews.location_id)
8.          

SubPlan (forNested Loop)

9. 0.850 0.850 ↑ 1.0 1 25

Seq Scan on system_codes (cost=0.00..9.06 rows=1 width=12) (actual time=0.024..0.034 rows=1 loops=25)

  • Filter: (("group" = 'DISTRIBUTORS'::text) AND (id = (reviews.source_provider)::text))
  • Rows Removed by Filter: 255
Planning time : 1.374 ms
Execution time : 291.386 ms