explain.depesz.com

PostgreSQL's explain analyze made readable

Result: hGId

Settings
# exclusive inclusive rows x rows loops node
1. 0.282 7.013 ↓ 1.0 793 1

Nested Loop (cost=927.29..1,640.77 rows=759 width=50) (actual time=4.732..7.013 rows=793 loops=1)

2. 0.263 5.938 ↓ 1.0 793 1

Nested Loop (cost=927.01..1,388.56 rows=759 width=32) (actual time=4.727..5.938 rows=793 loops=1)

3. 0.589 4.882 ↓ 1.0 793 1

Hash Right Join (cost=926.72..1,137.04 rows=760 width=28) (actual time=4.721..4.882 rows=793 loops=1)

  • Hash Cond: ("F_msrrvsn_units".id = "J_measrvsn".rvsn)
4. 0.802 0.802 ↑ 1.0 7,995 1

Seq Scan on "F_msrrvsn_units" (cost=0.00..175.28 rows=8,182 width=8) (actual time=0.007..0.802 rows=7,995 loops=1)

  • Filter: ("erasedAt" >= '9999-12-31 00:00:00'::timestamp without time zone)
5. 0.125 3.491 ↓ 1.0 793 1

Hash (cost=917.22..917.22 rows=760 width=24) (actual time=3.491..3.491 rows=793 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 52kB
6. 0.168 3.366 ↓ 1.0 793 1

Nested Loop (cost=303.16..917.22 rows=760 width=24) (actual time=2.204..3.366 rows=793 loops=1)

7. 0.842 2.405 ↓ 1.0 793 1

Hash Join (cost=302.87..665.91 rows=760 width=16) (actual time=2.196..2.405 rows=793 loops=1)

  • Hash Cond: (jmri.info = "J_ccdainfo".info)
8. 1.311 1.311 ↑ 1.0 14,181 1

Seq Scan on "J_msrrvsnii" jmri (cost=0.00..302.26 rows=14,181 width=8) (actual time=0.007..1.311 rows=14,181 loops=1)

  • Filter: ("erasedAt" >= '9999-12-31 00:00:00'::timestamp without time zone)
9. 0.094 0.252 ↑ 1.0 806 1

Hash (cost=292.80..292.80 rows=806 width=8) (actual time=0.252..0.252 rows=806 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 40kB
10. 0.158 0.158 ↑ 1.0 806 1

Index Scan using optimize5 on "J_ccdainfo" (cost=0.29..292.80 rows=806 width=8) (actual time=0.014..0.158 rows=806 loops=1)

  • Index Cond: (("erasedAt" >= '9999-12-31 00:00:00'::timestamp without time zone) AND (ccda = 88))
11. 0.793 0.793 ↑ 1.0 1 793

Index Scan using "PJ_measrvsn" on "J_measrvsn" (cost=0.29..0.32 rows=1 width=8) (actual time=0.001..0.001 rows=1 loops=793)

  • Index Cond: ((rvsn = jmri.revision) AND ("erasedAt" >= '9999-12-31 00:00:00'::timestamp without time zone))
12. 0.793 0.793 ↑ 1.0 1 793

Index Scan using "QF_msrrvsn_value" on "F_msrrvsn_value" (cost=0.29..0.32 rows=1 width=8) (actual time=0.001..0.001 rows=1 loops=793)

  • Index Cond: ((id = "J_measrvsn".rvsn) AND ("erasedAt" >= '9999-12-31 00:00:00'::timestamp without time zone))
13. 0.793 0.793 ↑ 1.0 1 793

Index Scan using optimize6 on "F_ccdaiteminfo_htmlname" (cost=0.29..0.32 rows=1 width=26) (actual time=0.001..0.001 rows=1 loops=793)

  • Index Cond: (id = jmri.info)
  • Filter: ("erasedAt" >= '9999-12-31 00:00:00'::timestamp without time zone)
Planning time : 1.619 ms
Execution time : 7.113 ms