explain.depesz.com

PostgreSQL's explain analyze made readable

Result: g8o0

Settings
# exclusive inclusive rows x rows loops node
1. 288.736 1,037.448 ↑ 1.0 757,083 1

Hash Left Join (cost=47.68..19,960.62 rows=761,840 width=538) (actual time=0.067..1,037.448 rows=757,083 loops=1)

  • Hash Cond: (document_type.verification_group_id = verification_groups.id)
2. 278.185 748.696 ↑ 1.0 757,083 1

Hash Left Join (cost=24.85..17,929.23 rows=761,840 width=482) (actual time=0.041..748.696 rows=757,083 loops=1)

  • Hash Cond: (client_documents.document_type_id = document_type.id)
3. 470.497 470.497 ↑ 1.0 757,083 1

Seq Scan on client_documents (cost=0.00..15,896.60 rows=761,840 width=433) (actual time=0.013..470.497 rows=757,083 loops=1)

4. 0.007 0.014 ↑ 58.9 18 1

Hash (cost=11.60..11.60 rows=1,060 width=49) (actual time=0.013..0.014 rows=18 loops=1)

  • Buckets: 2,048 Batches: 1 Memory Usage: 18kB
5. 0.007 0.007 ↑ 58.9 18 1

Seq Scan on document_types document_type (cost=0.00..11.60 rows=1,060 width=49) (actual time=0.005..0.007 rows=18 loops=1)

6. 0.010 0.016 ↑ 242.5 4 1

Hash (cost=10.70..10.70 rows=970 width=56) (actual time=0.016..0.016 rows=4 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
7. 0.006 0.006 ↑ 242.5 4 1

Seq Scan on verification_groups (cost=0.00..10.70 rows=970 width=56) (actual time=0.005..0.006 rows=4 loops=1)

Planning time : 0.356 ms
Execution time : 1,069.723 ms