explain.depesz.com

PostgreSQL's explain analyze made readable

Result: uspq

Settings
# exclusive inclusive rows x rows loops node
1. 34.513 884.158 ↓ 1.0 102,187 1

Hash Right Join (cost=19,350.47..19,942.21 rows=102,131 width=135) (actual time=831.427..884.158 rows=102,187 loops=1)

  • Hash Cond: ((mm.dvr_id = ff.dvr_id) AND (mm.ndmediachannel_id = bb.ndmediachannel_id))
2. 9.053 480.221 ↑ 2.8 1,669 1

Unique (cost=7,275.00..7,726.81 rows=4,664 width=44) (actual time=461.838..480.221 rows=1,669 loops=1)

3. 193.554 471.168 ↑ 1.0 59,746 1

Sort (cost=7,275.00..7,425.60 rows=60,241 width=44) (actual time=461.832..471.168 rows=59,746 loops=1)

  • Sort Key: mm.dvr_id, mm.ndmediachannel_id, mm.actiontime
  • Sort Method: quicksort Memory: 9938kB
4. 277.614 277.614 ↑ 1.0 59,746 1

Seq Scan on nddvrrecordingcheckhistory mm (cost=0.00..2,492.33 rows=60,241 width=44) (actual time=5.894..277.614 rows=59,746 loops=1)

  • Filter: (state > 0)
  • Rows Removed by Filter: 9
5. 52.921 369.424 ↓ 1.0 102,187 1

Hash (cost=10,543.51..10,543.51 rows=102,131 width=35) (actual time=369.424..369.424 rows=102,187 loops=1)

  • Buckets: 16384 Batches: 1 Memory Usage: 7456kB
6. 48.585 316.503 ↓ 1.0 102,187 1

Hash Right Join (cost=3,310.22..10,543.51 rows=102,131 width=35) (actual time=77.371..316.503 rows=102,187 loops=1)

  • Hash Cond: (aa.dvr_id = ff.dvr_id)
7. 129.976 262.233 ↓ 1.0 102,187 1

Hash Right Join (cost=3,051.73..8,242.05 rows=102,165 width=27) (actual time=71.665..262.233 rows=102,187 loops=1)

  • Hash Cond: (bb.ndmediachannel_id = aa.ndmediachannel_id)
8. 60.725 60.725 ↓ 1.0 108,188 1

Seq Scan on ndmediachannel bb (cost=0.00..3,087.68 rows=108,181 width=19) (actual time=0.004..60.725 rows=108,188 loops=1)

  • Filter: (NOT isdeleted)
  • Rows Removed by Filter: 80
9. 32.479 71.532 ↓ 1.0 102,187 1

Hash (cost=1,774.67..1,774.67 rows=102,165 width=16) (actual time=71.532..71.532 rows=102,187 loops=1)

  • Buckets: 16384 Batches: 1 Memory Usage: 4791kB
10. 39.053 39.053 ↓ 1.0 102,187 1

Seq Scan on nddvrandmediachannel aa (cost=0.00..1,774.67 rows=102,165 width=16) (actual time=0.003..39.053 rows=102,187 loops=1)

  • Filter: (NOT isdeleted)
  • Rows Removed by Filter: 80
11. 1.948 5.685 ↑ 1.0 6,021 1

Hash (cost=183.23..183.23 rows=6,021 width=16) (actual time=5.685..5.685 rows=6,021 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 288kB
12. 3.737 3.737 ↑ 1.0 6,021 1

Seq Scan on nddvr ff (cost=0.00..183.23 rows=6,021 width=16) (actual time=0.012..3.737 rows=6,021 loops=1)

  • Filter: (NOT isdeleted)
  • Rows Removed by Filter: 2