explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 8VVI

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 26.690 ↓ 0.0 0 1

Unique (cost=152,660.57..152,810.57 rows=20,000 width=38) (actual time=26.686..26.69 rows=0 loops=1)

  • Buffers: shared hit=2
2. 0.011 26.689 ↓ 0.0 0 1

Sort (cost=152,660.57..152,710.57 rows=20,000 width=38) (actual time=26.686..26.689 rows=0 loops=1)

  • Sort Key: headings.pmid, descriptors.descriptor_uid
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=2
3. 0.144 26.678 ↓ 0.0 0 1

Aggregate (cost=151,031.8..151,231.8 rows=20,000 width=38) (actual time=26.675..26.678 rows=0 loops=1)

  • Buffers: shared hit=2
4. 0.001 26.534 ↓ 0.0 0 1

Nested Loop (cost=1.19..101,031.8 rows=5,000,000 width=38) (actual time=26.531..26.534 rows=0 loops=1)

  • Buffers: shared hit=2
5. 0.001 26.533 ↓ 0.0 0 1

Nested Loop (cost=1.19..1,031.8 rows=50,000 width=69) (actual time=26.53..26.533 rows=0 loops=1)

  • Buffers: shared hit=2
6. 0.001 26.532 ↓ 0.0 0 1

Nested Loop (cost=1.19..31.8 rows=500 width=36) (actual time=26.53..26.532 rows=0 loops=1)

  • Buffers: shared hit=2
7. 0.009 26.531 ↓ 0.0 0 1

Hash Join (cost=1.19..21.8 rows=5 width=32) (actual time=26.529..26.531 rows=0 loops=1)

  • Buffers: shared hit=2
8. 0.019 0.019 ↑ 840.0 1 1

Seq Scan on pm_raw_xml_file rfx (cost=0..18.4 rows=840 width=36) (actual time=0.019..0.019 rows=1 loops=1)

  • Buffers: shared hit=1
9. 0.002 26.503 ↓ 0.0 0 1

Hash (cost=1.12..1.12 rows=5 width=4) (actual time=26.502..26.503 rows=0 loops=1)

  • Buffers: shared hit=1
10. 26.501 26.501 ↓ 0.0 0 1

Seq Scan on system_lookup_file_id_batch fil (cost=0..1.12 rows=5 width=4) (actual time=26.501..26.501 rows=0 loops=1)

  • Filter: ((NOT fil.is_extracted) AND (fil.batch_id = 1))
  • Buffers: shared hit=1
11. 0.000 0.000 ↓ 0.0 0 0

Table Function Scan (cost=0..1 rows=100 width=36) (never executed)

12. 0.000 0.000 ↓ 0.0 0 0

Table Function Scan (cost=0..1 rows=100 width=65) (never executed)

13. 0.000 0.000 ↓ 0.0 0 0

Table Function Scan (cost=0..1 rows=100 width=1) (never executed)

Planning time : 0.44 ms
Execution time : 32.065 ms