explain.depesz.com

PostgreSQL's explain analyze made readable

Result: FLbx

Settings
# exclusive inclusive rows x rows loops node
1. 0.072 6,801.398 ↑ 1.0 10 1

Nested Loop (cost=1.38..22,963.82 rows=10 width=123) (actual time=0.082..6,801.398 rows=10 loops=1)

2. 0.007 6,801.246 ↑ 1.0 10 1

Limit (cost=1.10..22,884.60 rows=10 width=24) (actual time=0.072..6,801.246 rows=10 loops=1)

3. 6,676.059 6,801.239 ↑ 241.8 10 1

GroupAggregate (cost=1.10..5,533,230.51 rows=2,418 width=24) (actual time=0.071..6,801.239 rows=10 loops=1)

  • Group Key: va.violation_id
4. 85.302 125.180 ↑ 545.1 438,290 1

Merge Join (cost=1.10..4,338,691.82 rows=238,902,902 width=39) (actual time=0.012..125.180 rows=438,290 loops=1)

  • Merge Cond: (va2.violation_id = va.violation_id)
5. 5.316 5.316 ↑ 644.3 1,158 1

Index Scan using violation_assets_uindx on violation_assets va2 (cost=0.55..376,641.59 rows=746,046 width=39) (actual time=0.006..5.316 rows=1,158 loops=1)

  • Filter: (state <> ALL ('{20,21,22,23,24,25,26,27}'::integer[]))
  • Rows Removed by Filter: 16
6. 32.888 34.562 ↑ 1.7 438,290 1

Materialize (cost=0.55..378,506.70 rows=746,046 width=16) (actual time=0.004..34.562 rows=438,290 loops=1)

7. 1.674 1.674 ↑ 644.3 1,158 1

Index Scan using violation_assets_uindx on violation_assets va (cost=0.55..376,641.59 rows=746,046 width=16) (actual time=0.003..1.674 rows=1,158 loops=1)

  • Filter: (state <> ALL ('{20,21,22,23,24,25,26,27}'::integer[]))
  • Rows Removed by Filter: 16
8. 0.080 0.080 ↑ 1.0 1 10

Index Scan using violations_pkey on violations v (cost=0.28..7.90 rows=1 width=132) (actual time=0.008..0.008 rows=1 loops=10)

  • Index Cond: (violation_id = va.violation_id)
Planning time : 0.417 ms
Execution time : 6,801.459 ms