explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 7QxF

Settings
# exclusive inclusive rows x rows loops node
1. 0.364 6.581 ↓ 1.0 793 1

Nested Loop (cost=607.87..1,078.44 rows=764 width=8) (actual time=5.257..6.581 rows=793 loops=1)

2. 0.673 5.424 ↓ 1.0 793 1

Hash Right Join (cost=607.58..821.41 rows=777 width=8) (actual time=5.245..5.424 rows=793 loops=1)

  • Hash Cond: ("F_msrrvsn_units".id = "J_msrrvsnii".revision)
3. 1.009 1.009 ↑ 1.0 8,270 1

Seq Scan on "F_msrrvsn_units" (cost=0.00..178.38 rows=8,270 width=4) (actual time=0.009..1.009 rows=8,270 loops=1)

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

Hash (cost=597.87..597.87 rows=777 width=8) (actual time=3.742..3.742 rows=793 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 39kB
5. 0.961 3.649 ↓ 1.0 793 1

Hash Join (cost=324.22..597.87 rows=777 width=8) (actual time=3.368..3.649 rows=793 loops=1)

  • Hash Cond: ("J_msrrvsnii".info = "J_ccdainfo".info)
6. 1.912 2.466 ↑ 1.0 14,488 1

Bitmap Heap Scan on "J_msrrvsnii" (cost=81.34..292.89 rows=14,488 width=8) (actual time=0.573..2.466 rows=14,488 loops=1)

  • Filter: ("erasedAt" >= '9999-12-31 00:00:00'::timestamp without time zone)
  • Heap Blocks: exact=121
7. 0.554 0.554 ↓ 2.0 14,488 1

Bitmap Index Scan on optimize8 (cost=0.00..77.72 rows=7,244 width=0) (actual time=0.554..0.554 rows=14,488 loops=1)

  • Index Cond: (("erasedAt" >= '9999-12-31 00:00:00'::timestamp without time zone) = true)
8. 0.086 0.222 ↑ 1.0 806 1

Hash (cost=232.57..232.57 rows=825 width=4) (actual time=0.222..0.222 rows=806 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 37kB
9. 0.136 0.136 ↑ 1.0 806 1

Index Only Scan using optimize9 on "J_ccdainfo" (cost=0.29..232.57 rows=825 width=4) (actual time=0.020..0.136 rows=806 loops=1)

  • Index Cond: (("erasedAt" >= '9999-12-31 00:00:00'::timestamp without time zone) AND (ccda = 88))
  • Heap Fetches: 98
10. 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_msrrvsnii".revision) AND ("erasedAt" >= '9999-12-31 00:00:00'::timestamp without time zone))
Planning time : 2.254 ms
Execution time : 6.694 ms